#include <mysql_driver.h>
#include <mysql_connection.h>
#include <iostream>
#include <string>

class MySQLClient {
public:
    MySQLClient(const std::string& host, const std::string& user, const std::string& password, const std::string& database);

    ~MySQLClient();

    // Function to execute an INSERT, UPDATE or DELETE query
    void executeQuery(const std::string& query) ;

    // Function to execute a SELECT query and process results
    void executeSelectQuery(const std::string& query);
    
    int loginSelectQuery(const std::string username , const std::string password ) ;


    bool connect( ) ;
private:
    sql::mysql::MySQL_Driver* driver;
    sql::Connection* con;
};
